//STEP 1. Import required packages

import java.sql.*;

public class DTNJDBCConnector
{
	private void Report(String message){
		//System.out.println(message);
	}
	
	// JDBC driver name and database URL
	static final String JDBC_DRIVER = "oracle.jdbc.driver.OracleDriver";
	
	static final String DB_URL = "jdbc:oracle:thin:@apollo.ite.gmu.edu:1521:ite10g";
	
	// Database credentials
	static final String USER = "infs612";
	
	static final String PASS = "spring2013";
	
	Connection conn = null;
	
	public PreparedStatement createConnection(String sql)
	{
		
		PreparedStatement stmt = null;
		try
		{
			// STEP 2: Register JDBC driver
			Class.forName("oracle.jdbc.driver.OracleDriver");
			
			// STEP 3: Open a connection
			Report("Connecting to database...");
			try
			{
				conn = DriverManager.getConnection(DB_URL, USER, PASS);
				
			}
			catch (SQLException e)
			{
				
				e.printStackTrace();
				
			}
			
			// STEP 4: Execute a query
			Report("Creating statement...");
			stmt = conn.prepareStatement(sql);
			
		}
		catch (SQLException e)
		{
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		catch (ClassNotFoundException e)
		{
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		finally
		{
		}
		return stmt;
	}
	
	public void release() throws SQLException
	{
		if(conn != null && !conn.isClosed())
			conn.commit();
			conn.close();
	}
}
	
	
   /*
   public static void main(String[] args) {
   Connection conn = null;
   Statement stmt = null;
   try{
   //STEP 2: Register JDBC driver
		Class.forName("oracle.jdbc.driver.OracleDriver");
	  


      //STEP 3: Open a connection
      System.out.println("Connecting to database...");
	  try {
      conn = DriverManager.getConnection(DB_URL,USER,PASS);
	
	  } catch (SQLException e) {
	  					
					e.printStackTrace();
					return;
		 
	  }
		
      //STEP 4: Execute a query
      System.out.println("Creating statement...");
      stmt = conn.createStatement();
      String sql;
      sql = "SELECT ROLE_CD, ROLE_DESC FROM PEC_ROLE_RFRNC";
      ResultSet rs = stmt.executeQuery(sql);

      //STEP 5: Extract data from result set
      while(rs.next()){
         //Retrieve by column name
         String roleCd = rs.getString("ROLE_CD");
         String roleDesc = rs.getString("ROLE_DESC");

         //Display values
         System.out.print("Role Code: " + roleCd);
         System.out.print(", Role Desc: " + roleDesc);
      }
      //STEP 6: Clean-up environment
      rs.close();
      stmt.close();
      conn.close();
   }catch(SQLException se){
      //Handle errors for JDBC
      se.printStackTrace();
   }catch(Exception e){
      //Handle errors for Class.forName
      e.printStackTrace();
   }finally{
      //finally block used to close resources
      try{
         if(stmt!=null)
            stmt.close();
      }catch(SQLException se2){
      }// nothing we can do
      try{
         if(conn!=null)
            conn.close();
      }catch(SQLException se){
         se.printStackTrace();
      }//end finally try
   }//end try
   System.out.println("Goodbye!");
}//end main
}//end FirstExample
*/